package com.sgam.mf.dao.ref;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.sgam.mf.dao.GenericDAOImpl;
import com.sgam.mf.domain.ref.RefCityHall;

@Repository
public class RefCityHallDAOImpl extends GenericDAOImpl<RefCityHall> implements RefCityHallDAO {

	@SuppressWarnings("unchecked")
	public List<RefCityHall> listByRegion(Integer id) {

		return getCurrentSession().createQuery("from RefCityHall where REF_REGION_FK="+id).list();
	}
	
}

	
